GEE Fusion Table tutorial - Create a Fusion Table

Tutorial walkthrough

Download/create a .csv file

note: this file should contain at least sites locations (WGS84) and a numerical value that can be used as classifier (e.g. this file where we should use elevation to classify sites)

Download the on your own computer

Such a window should pop-up.

Choose a suitable name and directory and save this file.

Go to Google Fusion Table web page and upload the .csv file

Open Google Fusion Table web page.

Click on create a fusion table > From this computer , search for you .csv file and click next

Check that the table is correctly formatted and click next

You can add a short description of what this table is, contains, … That should be helpful even more if you plan to share this table with collaborators. Click on finish.

define/check that location info are well defined

Check that your sites location is done according to the longitude and latitudes you gave.

Click Edit > Change columns

Define site_name variable as a Text

And latitude as a Location. Ensure that longitue is recognized as the complementary location (using Two columns location check-box)

Then save the modification and come back to the map. Check that your sites are correctly located on this map.

note: you can play with the way to display the sites via the filter option (e.g. display only locations having a elevation between 300m and 500m)

make the FT available on the web

Click on Share on the top right corner

Click on modifier.. and select Public.

Copy the id of your fusion table in the address bar of your browser (only part after docid=). This is the id you will use to import the fusion table in GEE.

try to import the FT in GEE workspace to be sure that it is working

Go to your GEE workspace.

Click on add data > Fusion Table

Paste you Fusion table id and load the table.

Choose a classification variable (e.g. elevation) and set up a classification that suits you.

You can then edit the classification to change names, color, …

You are done !!!

Note: In case you didn’t manage to make it or if you want to compare you results to mine you can use one of the following sections.

Link to the final fusion table / workspace

Here is the link to the final fusion table Here is the link to the final workspace

JSON version of the final workspace

Here is the Json version of the final workspace. You can copy this lines and import them in your workspace.

{
  "viewport": {
    "zoom": 3,
    "lat": 66.79190947341799,
    "lng": -51.15234375
  },
  "name": "",
  "classmodel": [
    {
      "name": "< 100m",
      "color": "d63000"
    },
    {
      "name": "100m < ele < 200m",
      "color": "98ff00"
    },
    {
      "name": "200m < ele < 300m",
      "color": "0B4A8B"
    },
    {
      "name": "> 300m",
      "color": "ffc82d"
    }
  ],
  "polylayers": [
    {
      "title": "Fusion Table: itex_sites_sample",
      "originaltitle": null,
      "overlayvisible": true,
      "layermode": "advisory-mode",
      "datatype": "table",
      "mapping": [
        [
          26,
          0
        ],
        [
          158,
          1
        ],
        [
          208,
          2
        ],
        [
          268,
          2
        ],
        [
          397,
          3
        ]
      ],
      "id": "1eEaV0k3lg2bQsJc-Pm3oIXNR-I4dfrYfV41cnMHM",
      "class_column": "elevation",
      "geometry_column": null
    }
  ],
  "datalayers": [],
  "drawnpoints": [
    [],
    [],
    [],
    []
  ],
  "drawnpolys": [
    [],
    [],
    [],
    []
  ],
  "analysis": null
}